{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["QGE94XLS"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"QGE94XLS","index":0,"n_rows":33,"n_cols":38,"rows_kept":33,"merged":[[4,4,4,6],[4,12,4,13]],"flags":["formulas_cached_only"]}
[{"$nulls":5}," ",{"$nulls":19}," "]
[]
["2002-07-25T23:28:52.690",{"$nulls":15},"US$ =",2.995,"IBVSP  =",{"v":-44.84764386594584,"d":"(44.85)"},null,"2002-07-25T23:28:52.690",36658.415715393516]
[]
[" ","TP.","Part.","N. Ações","Lucro Líquido MM",null,null,"LPA","LPA ","Valor","Cotação","       P/L Projetado (1)","     P/L Proj. (1)",null,"P/L","Desvio","Yield","VPA","Relação","Lucrat.",null," ","          Vendas Líquidas (MM)",null,null,"PTLQ","        RENT / PTLQ  (6)",null,null,"     Lucro Parcial  02 (MM)",null,null,"Acum. (MM)","                             PREÇO (R$)  (7)",null,null," Mkt Value","PSR"]
["EMPRESAS"," "," (%)","(milhões)",2001,2002,2003,2002,2003,"Econômico","2002-07-25T23:28:52.690",1996,2002,2003,"Médio","Padrão","Proj."," ","P / VPA","Ano ",null,"EMPRESAS",2001,2002,2003,"2001 (MM)",2001,2002,2003,"I Tri","II Tri","III Tri",2002,"Mínimo","Justo","Máximo"," (US$ MM)"," "]
[" "," "," "," ","US$ / R$","US$ / R$","US$ / R$","US$","US$","R$","R$",null," "," "," (1.1)"," (2)","(%)"," (3)"," (4)","US$ (5)",null," ","US$ / R$","US$ / R$","US$ / R$","US$ / R$","(%)","(%)","(%)","US$ / R$","US$ / R$","US$ / R$","US$ / R$"," "," "," ","(8)"," (9)"]
["TELERJ FIXA *",null,{"v":100,"d":"100.00"},{"v":68446.359,"d":"68,446 "},{"$error":"#VALUE!"},{"v":102.75372112648533,"d":"102.8"},{"v":214.78710728213963,"d":"214.8"},{"v":1.501229906567935,"d":"1.50"},{"v":3.138035542287058,"d":"3.14"},null,null,{"$error":"#VALUE!"},{"$nulls":4},{"$error":"#DIV/0!"},{"v":54.836474208949525,"d":"54.84"},{"$nulls":3},"TELERJ FIXA *"," ",{"v":4258.900227267239,"d":"4,259 "},{"v":4352.219879650612,"d":"4,352 "}," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":4.476838113244281,"d":"4.48"},{"v":1.7954293116210214,"d":"1.8"},{"v":-10.021692915093931,"d":"(10.0)"},null,{"v":-8.337888845503059,"d":"(8.3)"},{"$nulls":3},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"}]
[null,"PN",{"v":27.161495909519456,"d":"27.16"},{"v":18591.055,"d":"18,591 "},{"$error":"#VALUE!"},{"v":238.42973450189655,"d":"238.4"},{"v":565.7683135889422,"d":"565.8"},null,null,{"v":0,"d":"0.00"},"NA",{"v":0,"d":"0.00"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"-","-",null,null,{"$error":"#VALUE!"},{"v":-100,"d":"(100.00)"},null,null,{"$error":"#VALUE!"},{"v":9957.135890983249,"d":"9,957 "},{"v":11198.460947208627,"d":"11,198 "},{"$error":"#VALUE!"},{"$nulls":3},{"v":3.881,"d":"3.9"},{"v":-23.099,"d":"(23.1)"},null,{"v":-19.218,"d":"(19.2)"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"ON",{"v":72.83850409048055,"d":"72.84"},{"v":49855.304,"d":"49,855 "},{"$nulls":6},"NA",{"v":0,"d":"0.00"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":34.68869440861674,"d":"34.7"},{"v":2.8015919570502383,"d":"2.8"},null,null,{"$error":"#VALUE!"},{"v":-100,"d":"(100.00)"},{"$nulls":13},{"v":143.37026614309164,"d":"143.37"},{"v":155.96673787070404,"d":"155.97"},{"v":168.56320959831643,"d":"168.56"}]
["TELEMIG FIXA",null,{"v":100,"d":"100.00"},{"v":24847.194502,"d":"24,847 "},{"v":257.9929342367928,"d":"258.0"},{"v":219.95806864061146,"d":"220.0"},{"v":276.00826588680786,"d":"276.0"},{"v":8.852430749190079,"d":"8.85"},{"v":11.10822655912286,"d":"11.11"},null,null,{"$error":"#REF!"},{"$nulls":4},{"$error":"#DIV/0!"},{"v":96.07277794713823,"d":"96.07"},{"$nulls":3},"TELEMIG FIXA",{"v":1042.8000639549196,"d":"1,043 "},{"v":950.9996717510259,"d":"951 "},{"v":1055.2175844942772,"d":"1,055 "},{"v":1149.1230382530425,"d":"1,149 "},{"v":23.672087123947556,"d":"23.67"},{"v":19.141385327632392,"d":"19.14"},{"v":25.21977326964679,"d":"25.22"},{"v":42.809492968171725,"d":"42.8"},{"v":63.250900255976404,"d":"63.3"},null,{"v":103.39884593691701,"d":"103.4"},{"$nulls":3},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"}]
[null,"PNB",{"v":66.92692188423304,"d":"66.93"},{"v":15935.194502,"d":"15,935 "},{"v":504.47938360662465,"d":"504.5"},{"v":510.39070247367476,"d":"510.4"},{"v":727.0302817676277,"d":"727.0"},null,null,{"v":0,"d":"0.00"},"NA",{"v":0,"d":"0.00"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":6.243967057138194,"d":"6.2"},{"v":1.1156450148439607,"d":"1.1"},null,null,{"$error":"#VALUE!"},{"v":-100,"d":"(100.00)"},null,null,{"v":1906.0820968999997,"d":"1,906 "},{"v":2223.39863781722,"d":"2,223 "},{"v":2715.123141185508,"d":"2,715 "},{"v":2246.9951889999993,"d":"2,247 "},{"$nulls":3},{"v":92.537,"d":"92.5"},{"v":145.787,"d":"145.8"},null,{"v":238.324,"d":"238.3"},{"v":135.96735663816943,"d":"135.97"},{"v":165.54648649075241,"d":"165.55"},{"v":195.1256163433354,"d":"195.13"}]
[null,"ON",{"v":37.42989944411567,"d":"37.43"},{"v":8912,"d":"8,912 "},{"$nulls":6},"NA",{"v":0,"d":"0.00"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"v":5.300778815655615,"d":"5.3"},{"v":0.03125586347725785,"d":"0.0"},null,null,{"$error":"#VALUE!"},{"v":-100,"d":"(100.00)"},{"$nulls":13},{"v":139.7110206112026,"d":"139.71"},{"v":140.53970826018357,"d":"140.54"},{"v":141.36839590916458,"d":"141.37"}]
["TELEMIG CELULAR",null,{"v":100,"d":"100.00"},{"v":23809.842218,"d":"23,810 "},{"v":41.653175984003866,"d":"41.7"},{"v":31.95122617534823,"d":"32.0"},{"v":39.59894395963709,"d":"39.6"},{"v":1.3419335534778731,"d":"1.34"},{"v":1.6631334049622841,"d":"1.66"},null,null,{"$error":"#REF!"},{"$nulls":4},{"v":5.072165504369252,"d":"5.07"},{"v":22.10724435637249,"d":"22.11"},{"$nulls":3},"TELEMIG CELULAR",{"v":368.70032141621226,"d":"369 "},{"v":350.9360815047256,"d":"351 "},{"v":367.3318814634964,"d":"367 "},{"v":193.87854651045387,"d":"194 "},{"v":19.25307066654767,"d":"19.25"},{"v":16.480021513687916,"d":"16.48"},{"v":21.03740695879589,"d":"21.04"},{"v":13.194181442589088,"d":"13.2"}," "," ",{"v":13.194181442589088,"d":"13.2"},{"$nulls":3},{"v":269.2962045145242,"d":"269.3"},{"v":0.7673653941761983,"d":"0.77"}]
[null,"PNC",{"v":62.56834406377417,"d":"62.57"},{"v":14897.424,"d":"14,897 "},{"v":96.65202955328256,"d":"96.7"},{"v":84.16236700175908,"d":"84.2"},{"v":112.07010645176251,"d":"112.1"},null,null,{"v":87.96095045566811,"d":"87.96"},{"v":33.5,"d":"33.50"},{"v":0,"d":"0.00"},{"v":8.335218103080665,"d":"8.3"},{"v":6.72544295887905,"d":"6.7"},{"v":9.510129183808138,"d":"9.5"},{"v":0.9442587259019741,"d":"0.9"},null,null,{"v":1.515340377116857,"d":"1.52"},{"v":-26.889040419478473,"d":"(26.89)"},null,null,{"v":855.5322258141789,"d":"856 "},{"v":924.3968016647816,"d":"924 "},{"v":852.356897747897,"d":"852 "},{"v":449.8757793228571,"d":"450 "},{"$nulls":3},{"v":30.658,"d":"30.7"}," "," ",{"v":30.658,"d":"30.7"},{"v":34.427012801716415,"d":"34.43"},{"v":38.22207454173554,"d":"38.22"},{"v":42.01713628175465,"d":"42.02"}]
[null,"ON",{"v":37.43165593622583,"d":"37.43"},{"v":8912.418218,"d":"8,912 "},{"$nulls":6},{"v":34.5,"d":"34.50"},{"v":0,"d":"0.00"},{"v":8.58403058376964,"d":"8.6"},{"v":6.926202450188873,"d":"6.9"},{"v":8.83263371521385,"d":"8.8"},{"v":1.0250276470817135,"d":"1.0"},null,null,{"v":1.560574418224823,"d":"1.56"},{"v":-17.067488113657202,"d":"(17.07)"},{"$nulls":12}," ",{"v":31.379479222716075,"d":"31.38"},{"v":35.499158606336046,"d":"35.50"},{"v":39.61883798995603,"d":"39.62"}]
["BRASIL TELECOM",null,{"v":100,"d":"100.00"},{"v":532734.4874430001,"d":"532,734 "},"-",{"v":109.89619570160073,"d":"109.9"},{"v":155.59951975176105,"d":"155.6"},{"v":0.20628699341219028,"d":"0.21"},{"v":0.29207705417871865,"d":"0.29"},null,null,{"$error":"#REF!"},{"$nulls":4},{"v":0.5133244486741229,"d":"0.51"},{"v":12.870388836490731,"d":"12.87"},{"$nulls":3},"BRASIL TELECOM",{"v":2633.9853288128384,"d":"2,634 "},{"v":2596.2662140912657,"d":"2,596 "},{"v":2639.6564896418004,"d":"2,640 "},{"v":3102.9458101297055,"d":"3,103 "},{"v":2.998953249569625,"d":"3.00"},{"v":3.541673056063038,"d":"3.54"},{"v":5.6955140270750375,"d":"5.70"},{"v":27.586503701153383,"d":"27.6"}," "," ",{"v":27.586503701153383,"d":"27.6"},{"$nulls":3},{"v":1661.915575126611,"d":"1,661.9"},{"v":0.6401175527018549,"d":"0.64"}]
[null,"PN",{"v":55.48150100224635,"d":"55.48"},{"v":295569.08999,"d":"295,569 "},"-",{"v":289.47633821550687,"d":"289.5"},{"v":440.3666612977726,"d":"440.4"},null,null,{"v":28.59020060733102,"d":"28.59"},{"v":10.1,"d":"10.10"},{"v":0,"d":"0.00"},{"v":16.34755099902866,"d":"16.3"},{"v":11.545881804116682,"d":"11.5"},{"v":22.305277022248674,"d":"22.3"},{"v":2.5718734469763165,"d":"2.6"},null,null,{"v":0.7847470755012471,"d":"0.78"},{"v":-38.019365609348924,"d":"(38.02)"},null,null,{"v":6111.89955697731,"d":"6,112 "},{"v":6838.795755300469,"d":"6,839 "},{"v":6125.058918564833,"d":"6,125 "},{"v":7200.075457824968,"d":"7,200 "},{"$nulls":3},64.1," "," ",64.1,{"v":12.191879757530243,"d":"12.19"},{"v":13.780859159766347,"d":"13.78"},{"v":15.369838562002451,"d":"15.37"}]
[null,"ON",{"v":44.518498997753646,"d":"44.52"},{"v":237165.397453,"d":"237,165 "},{"$nulls":6},{"v":8.4,"d":"8.40"},{"v":0,"d":"0.00"},{"v":13.595983009093143,"d":"13.6"},{"v":9.602515559859418,"d":"9.6"},{"v":17.81824504224687,"d":"17.8"},{"v":1.6734554939348363,"d":"1.7"},null,null,{"v":0.6526609340802452,"d":"0.65"},{"v":-40.71927960742653,"d":"(40.72)"},{"$nulls":12}," ",{"v":9.97472798510556,"d":"9.97"},{"v":11.008638231952082,"d":"11.01"},{"v":12.042548478798606,"d":"12.04"}]
["TELEPAR CELULAR",null,{"v":100,"d":"100.00"},{"v":4237.174841,"d":"4,237 "},{"v":-7.8838912029755805,"d":"(7.9)"},{"v":3.161309965476784,"d":"3.2"},{"v":11.118210115061094,"d":"11.1"},{"v":0.7460891004277498,"d":"0.75"},{"v":2.62396774555499,"d":"2.62"},null,null,{"$error":"#REF!"},{"$nulls":4},{"v":0.8981407674590108,"d":"0.90"},{"v":72.27551646835619,"d":"72.28"},{"$nulls":3},"TELEPAR CELULAR",{"v":179.56855213447733,"d":"180 "},{"v":184.4283722143189,"d":"184 "},{"v":192.51272153506048,"d":"193 "},{"v":134.41268289950028,"d":"134 "},{"v":-4.668914952185379,"d":"(4.67)"},{"v":2.351943207502584,"d":"2.35"},{"v":9.259298394784505,"d":"9.26"},{"v":-1.6930624892408332,"d":"(1.7)"}," "," ",{"v":-1.6930624892408332,"d":"(1.7)"},{"$nulls":3},{"v":100.31538182036726,"d":"100.3"},{"v":0.5439259730807234,"d":"0.54"}]
[null,"PNB",{"v":43.727437963422005,"d":"43.73"},{"v":1852.808,"d":"1,853 "},{"v":-18.293781147384536,"d":"(18.3)"},{"v":8.32717117210528,"d":"8.3"},{"v":31.46596516356642,"d":"31.5"},null,null,{"v":244.6528070353818,"d":"244.65"},{"v":69.5,"d":"69.50"},{"v":0,"d":"0.00"},{"v":31.10264206213121,"d":"31.1"},{"v":8.84360803457729,"d":"8.8"},{"v":41.44381748183161,"d":"41.4"},{"v":7.863644694452409,"d":"7.9"},null,null,{"v":0.9615981095123496,"d":"0.96"},{"v":-26.23879982619437,"d":"(26.24)"},null,null,{"v":416.67086837284114,"d":"417 "},{"v":485.80070957697336,"d":"486 "},{"v":446.7065190499543,"d":"447 "},{"v":311.8911894000004,"d":"312 "},{"$nulls":3},{"v":-3.934,"d":"(3.9)"}," "," ",{"v":-3.934,"d":"(3.9)"},{"v":75.03613371689673,"d":"75.04"},{"v":92.60773760741823,"d":"92.61"},{"v":110.17934149793975,"d":"110.18"}]
[null,"ON",{"v":56.272562036578,"d":"56.27"},{"v":2384.366841,"d":"2,384 "},{"$nulls":6},{"v":72,"d":"72.00"},{"v":0,"d":"0.00"},{"v":32.221442136308596,"d":"32.2"},{"v":9.16172343150453,"d":"9.2"},{"v":47.555341854349315,"d":"47.6"},{"v":10.739289059947467,"d":"10.7"},null,null,{"v":0.9961879695667507,"d":"1.00"},{"v":-53.11995045668883,"d":"(53.12)"},{"$nulls":12}," ",{"v":82.26682685347409,"d":"82.27"},{"v":106.26416406281356,"d":"106.26"},{"v":130.26150127215308,"d":"130.26"}]
["TELEMAR NORTE LESTE",null,{"v":100,"d":"100.00"},{"v":245648.889935,"d":"245,649 "}," ",{"v":214.78710728213963,"d":"214.8"},{"v":358.17636851313745,"d":"358.2"},{"v":0.8743662848994491,"d":"0.87"},{"v":1.4580825853025952,"d":"1.46"}," "," ",{"$error":"#REF!"}," "," "," "," ",{"v":2.705085081367685,"d":"2.71"},{"v":44.535108637758476,"d":"44.54"}," "," ",null,"TELEMAR NORTE LESTE"," ",{"v":4352.219879650612,"d":"4,352 "},{"v":4303.19823428793,"d":"4,303 "},{"v":4359.555027599213,"d":"4,360 "}," ",{"v":4.476838113244281,"d":"4.48"},{"v":8.215892820382258,"d":"8.22"},{"v":88.65553451540713,"d":"88.7"}," "," ",{"v":88.65553451540713,"d":"88.7"}," "," "," ",{"v":3017.247085106344,"d":"3,017.2"},{"v":0.7011638601877289,"d":"0.70"}]
["* (Ex Telerj reestrurada)","PNB",{"v":0.843325765301916,"d":"0.84"},{"v":2071.620381,"d":"2,072 "}," ",{"v":565.7683135889422,"d":"565.8"},{"v":1013.6852080875773,"d":"1,013.7"}," "," ",{"v":135.4796948327652,"d":"135.48"},{"v":40,"d":"40.00"},{"v":0,"d":"0.00"}," "," "," "," "," "," ",{"v":0.8981677876965265,"d":"0.90"}," ",null,"* (Ex Telerj reestrurada)"," ",{"v":11464.133638355253,"d":"11,464 "},{"v":9985.141182841711,"d":"9,985 "}," "," "," "," ",{"v":206,"d":"206.0"}," "," ",{"v":206,"d":"206.0"}," "," "," "," "," "]
[null,"PNA",{"v":55.52245867632034,"d":"55.52"},{"v":136390.30340300003,"d":"136,390 "},{"$nulls":5}," ",{"v":40.5,"d":"40.50"},{"v":0,"d":"0.00"},{"v":15.465529488204606,"d":"15.5"},{"v":9.27419180429894,"d":"9.3"},{"v":22.857256511289304,"d":"22.9"},{"v":2.843575721143325,"d":"2.8"}," "," ",{"v":0.9093948850427331,"d":"0.91"}," ",null,null," "," "," "," "," "," "," "," "," "," ",{"v":0,"d":"0.0"},{"v":52.41036672033202,"d":"52.41"},{"v":59.856915304015466,"d":"59.86"},{"v":67.30346388769892,"d":"67.30"}," "," "]
[null,"ON",{"v":43.63421555837775,"d":"43.63"},{"v":107186.966151,"d":"107,187 "},{"$nulls":5}," ",{"v":32,"d":"32.00"},{"v":0,"d":"0.00"},{"v":12.219677620309813,"d":"12.2"},{"v":7.327756487347312,"d":"7.3"},{"v":19.22161667167368,"d":"19.2"},{"v":3.1355316863116034,"d":"3.1"}," "," ",{"v":0.7185342301572212,"d":"0.72"}," ",null,null," "," "," "," "," "," "," "," "," "," "," ",{"v":42.12506544984741,"d":"42.13"},{"v":50.336167009123024,"d":"50.34"},{"v":58.54726856839865,"d":"58.55"}," "," "]
[" ",{"$nulls":10},{"$error":"#REF!"},{"v":13.382766196771309,"d":"13.4"},{"v":9.09728115046799,"d":"9.1"},{"$nulls":4},{"v":1.4702227585417131,"d":"1.47"},{"$nulls":17},{"v":5048.774246567847,"d":"5,048.8"},{"v":0.6631431950366263,"d":"0.7"}]
["    Média das empresas com exclusão ( PL's < 20 )",{"$nulls":10},{"$error":"#REF!"},{"v":13.382766196771309,"d":"13.4"},{"v":9.09728115046799,"d":"9.1"},{"$nulls":4},{"v":1.2744701131764289,"d":"1.27"}]
[{"$nulls":18}," "]
[{"$nulls":18}," "]
[" (1) Cotação da ação em US$ sobre o LPA em US$.",{"$nulls":3}," (2) Desvio Padrão do P/L médio.",{"$nulls":7}," (4) Relação entre a cotação na data do QGE e o VPA.",{"$nulls":8}," (6) Relação percentual entre o lucro líquido /  PTLQ anterior ( Base Anual em dólar).",{"$nulls":7}," (7) Preços avaliados - critério: P=(P/L médio ± o Desvio Padrão) X LPA proj. de 2002."]
[" (1.1) P/L médio histórico dos últimos 12 meses.",{"$nulls":3}," (2) Desvio Padrão do P/L médio.",{"$nulls":7}," (5) Variação % entre 28/12/01 até a data do QGE (em US$).",{"$nulls":8}," (8) Mkt Value ponderado pelas quantidades de ON e PN e os seus respectivos preços.",{"$nulls":7}," (9) Relação entre o Valor de Mercado e a Vendas líquidas projetadas para  2002."]
[" Valor econômico = Valor da empresa por lote de mil ações em função do fluxo de caixa descontado projetado."]